E-forms is a script that handles data sent to you via e-mail from html forms. It REQUIRES that you have installed "Decode URL", "Tokenize" and "Replace" extensions in your Scripting Additions Folder. "Tokenize" and "Replace" are part of the ACME Script Widgets, which you'll find, along with "Decode URL", at http://www.biap.com/machttp/tools.html.You will also find a link to the most recent versions in my home page, at the address written below.
E-forms also requires both Eudora and FileMaker Pro, and, obviously, AppleScript.
- How to install
Just drop the script in the AppleMenu so that it is available from any application
- How does it work?
E-forms can work in two different ways; both of them require that, before launching the script, you have opened the FileMaker Pro file where you want to import data. This file should have as many fields as the HTML form plus one, named Date, for auto-importing Eudora's date field.
1) If you want to process a single message just select the message in Eudora, launch E-forms from the Apple Menu and follow the instructions.
2) If you want to process multiple messages at a time you have to create 2 new mailboxes in Eudora: one, which has to be named Forms, for messages still to be processed, and the other (StoredForms) for storing processed messages (provided that you want to keep a copy also in Eudora of processed messages instead of trashing them). Once you have set up this, and opened the destination database, you can launch E-forms from the AppleMenu, click All in the second dialog box and have a coffee break.
When E-forms has finished importing in FMP it will ask you what you do want to do with the processed forms: choose the desired option in the dialog box.
- What's more?
I also included a little script to reply to the sender of the form from FileMaker Pro. To use the Reply button you need to have named two of the database fields as email and comments respectively.
The content of the email field will be put in the "To:" field in a new Eudora message, and the content of the "Comments" field will be quoted in the new message. The subject will be "Thanks for visiting my home page!" but you can easyly modify it as desired with a lttle AppleScript knowledge, as well as the standard reply message.
The last word
E-forms is email-ware, so, if you use it, please drop me a line. Better since, visit my home page, and sign my guest book! If you send me whatever you think it's worth I will send you the source, but please do not send cheques, unless you live in Italy - they're too expensive to cash!
The E-forms package can be uploaded wherever you want, but, please, do not modify it. If you’re including it on CD-ROMs etc. please drop me a line.
Comments, bug reports and suggestions are very welcome!
Riccardo Canetta
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ o ~~~~~~~~~~~~
